Tabela LPatientEmployer

Definicja tabeli LPatientEmployer

Name

LPatientEmployer

Code

LPatientEmployer

Comment

 


Lista kolumn tabeli LPatientEmployer

Name

Code

LPatientEmployerID

LPatientEmployerID

EmployerID

EmployerID

PersonID

PersonID

StartDT

StartDT

StopDT

StopDT

Comments

Comments


Kolumna LPatientEmployerID tabeli LPatientEmployer

Definicja kolumny LPatientEmployerID tabeli LPatientEmployer

Name

LPatientEmployerID

Code

LPatientEmployerID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna EmployerID tabeli LPatientEmployer

Definicja kolumny EmployerID tabeli LPatientEmployer

Name

EmployerID

Code

EmployerID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PersonID tabeli LPatientEmployer

Definicja kolumny PersonID tabeli LPatientEmployer

Name

PersonID

Code

PersonID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna StartDT tabeli LPatientEmployer

Definicja kolumny StartDT tabeli LPatientEmployer

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Kolumna StopDT tabeli LPatientEmployer

Definicja kolumny StopDT tabeli LPatientEmployer

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

PL: Data koncowa
EN: Stop date
DE: Das Endedatum


Kolumna Comments tabeli LPatientEmployer

Definicja kolumny Comments tabeli LPatientEmployer

Name

Comments

Code

Comments

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Lista kluczy tabeli LPatientEmployer

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli LPatientEmployer

Definicja klucza Identifier_1 tabeli LPatientEmployer

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment